NYC Education¶
Introduction¶
“Achieving inclusive and quality education for all reaffirms the belief that education is one of the most powerful and proven vehicles for sustainable development.” - UN
It should be the goal of any governing organization to ensure high-quality education for all, as its benefits are high and extensive. From the fact that illiteracy means you have a substantially higher likelihood of ending up in jail or on welfare, that illiteracy has a negative impact on discrimination and preventable diseases, or the fact that for every dollar spent on adult illiteracy the ROI (return on investment) is 6.14$ (614%). Another extremely important effect of education is the social network you get, which combats loneliness which in itself has a number of negative health impacts [1].
Given that there is no doubt about the importance of education it’s important to investigate when the educational system fails and people drop out, and which factors have an impact on the dropout. To investigate this we’ll look at poverty data from New York City in 2015, where we focus on education, since this is one of the 17 SDG, and education is important for developing our world in a sustainable direction.
The Data¶
The data can be obtained from data.cityofnewyork.
It contains 69103 observations and 61 columns of which we only use a subset of 11 columns:
Age of person (AGEP)
Borough (Bronx, Brooklyn, Manhattan, Queens, Staten Island) (Boro)
Disability (DIS)
Level of education (no high school, high school, some college, bachelor degree or above) (EducAttain)
Ethnicity (white, black, asian hispanic, other)
Language other than english spoken at home (yes/no) (LANX)
Sex (SEX)
Total income
Interest, dividends, and net rental income (INTP_adj)
Self-employment income (SEMP_adj)
Wages or salary income (WAGP_adj)
Retirement income (RETP_adj)
We mainly use the peoples educational status, since this is what we are interested in investigating. Additionally we use other above stated features, to see which have an influence on the education.
Furthermore, we are only looking at adults (people older than 24 years old) as people younger than 24 have not had a fair opportunity to finish a bachelor degree. Hence we remove all rows with younger people, this gives us a little less than 50000 participants.
The data is generated annually by a research unit in the Mayor’s office. It is derived from the American Community Survey Public Use Microsample for NYC.
An investigation of the impact of education on salary¶
An obvious attribute that we would expect education to have an impact on is income. It is intuitive that more education leads to better and more well-paid jobs, so let’s investigate this claim. We’ll do this by looking at the distribution of total income
Interestingly, the individual with second highest income is (the max line in green) without a high school diploma ie. more than both people with a high school degree and some college. What this means is just that a high salary/income can be obtained without having any education and not that you can expect a lower maximum income if you have some college education. In fact what we see is indeed that you can expect a higher salary the higher your education level. This can be seen in both the average (red line), and median (purple line). Thus it’s easy to conclude that education is an effective tool against poverty. However, it’s important to note that we know nothing of the jobs that people occupy, so a higher salary does not necessarily mean a job that is a “vehicle for sustainable development” [UN].
Sex a hopeful story¶
SDG 4 says: “Ensure inclusive and equitable quality education and promote lifelong learning opportunities for all” [2] this unsurprisingly also includes women. Worldwide we know there is a discrepancy between males and females from Hans Rosling’s quiz in the opening of his famous book Factfulness: “Worldwide, 30-year-old men have spent 10 years in school, on average. How many years have women of the same age spent in school?” the answer is 9 years [3]. This number is of course not US or NYC specific, thus let’s take a look at the distribution of sexes for the different achieved educations in NYC:
It’s fairly clear that there is no difference in education obtained between the sexes. So nonetheless they are doing pretty good in NYC regarding gender equality in the educational system
Salary and Sex a sad story¶
Although the equality of education between the sexes is a good sign, it’s an entirely different and alarming story when looking at sex and salary:
Here we have a fairly big discrepancy as both the average and median is significantly higher for males (about 70%). This is very alarming as it contradicts our previous conclusion: that higher education means a higher salary and thus an effective tool against poverty. The two figures above suggest that although females have an equal amount of education as men, they still have a lower average salary, and thus a higher likelihood of being in poverty. Now you might think that this low salary could be explained by “Stay-at-home-moms” but there is a difference in salary between men and women even when removing instances of people not earning any money:
The difference is still significant (about 35%). And even if the the entire difference could be explained by stay-at-home-momes, there is still a question if it should be the case, as this is gender inequality no matter if it is voluntary or not.
Ethnicity, age and education¶
NYC is a multicultural city with people coming from all ethnicities, does all of them get the same opportunities for educations?
We do see that for white, Asian, and other over 50% have a higher education, whereas majority of the Hispanic in our dataset have less than high school education which is beneath SDG 4.1. But could this be a historical issue and no longer be the case? Looking at the general education we would expect it to be higher the lower the age (for people older than 24 years old), since the focus on education and resource helping people to get an education has changed dramatically. Additionally, the American society is generally less segregated, especially compared to say the 60s, thus we would expect to see a greater increase in education for all other races.
The Hispanic race seems to be having the most trouble with obtaining an education even for the younger generation of 20-30, where there are still some age groups where high school education is the most frequent. This may be troublesome for many increasing importance of a college degree steady increasing [5]. But alike our theory the younger generation is having a higher education which is a result of the increase focus in education.
Borough¶
New York City is divided into five different borough each with it’s own flavor [11]:
Bronx one of the most prominent centres of urban poverty in the United States.
Brooklyn collision of old and new
Manhattan center of NYC and the representative of NYC with central Park, Broadway show and Times Square
Queens primary middle-class families and the most ethnically varied of all the boroughs
Staten Island the most rural part of the city
We wish to see how the borough have influence on the education, and if this reflects the salary of the people. Furthermore we take a look at the ethnicities in the boroughs to see if these maybe are related and can explain the educational situation. To investigate this we have created the following heatmap.
sdjafdm klfdklsæ afnklæew klqræ klæ kldsæafds